revDatabaseColumnNumbered
Type
function
Summary
Returns data from a specified database field.
Syntax
revDatabaseColumnNumbered(<recordSetID>, <columnNumber> [, <holderVariable>])
Description
Use the revDatabaseColumnNumbered function to obtain the contents of a given database field, in the current record of the specified record set.
If you specify a holderVariable, the data is placed in that variable. Otherwise, the data is returned by the function. In order to retrieve binary data, a holder variable must be specified, otherwise the revDatabaseColumnNumbered function may return truncated data. This is due to limitations in the current architecture.
If the attempt to get the data is not successful, the revDatabaseColumnNumbered function returns an error message that begins with the string "revdberr".
The revDatabaseColumnNumbered function is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions pane of the Standalone Application Settings window, make sure both the "Database" library checkbox and those of the database drivers you are using are checked.
Parameters
| Name | Type | Description |
|---|---|---|
recordSetID | integer | The number returned by the revQueryDatabase when the record set was created. |
columnNumber | integer | The number of a database field. |
holderVariable | string | Any valid variable name or the name of an array element. |
Examples
revDatabaseColumnNumbered(customerServiceDB, 3)
revDatabaseColumnNumbered(7, 3, "tNewColumn") -- puts column 3 into tNewColumn
revDatabaseColumnNumbered(USCustomers, x, "tFoundZipCodes")
revDatabaseColumnNumbered(tCursor, 1, "tRetrievedDataArray[id]")
Related
keyword: string
library: Database library
command: revMoveToLastRecord, revMoveToFirstRecord, revMoveToNextRecord
constant: empty
control structure: function
function: revDatabaseColumnCount, revCurrentRecord, revDatabaseColumnNamed, revDatabaseColumnLengths, revDatabaseColumnIsNull
glossary: LiveCode custom library, return, variable, record set, record, Standalone Application Settings, standalone application, database field
Compatibility and Support
Introduced
LiveCode 1.1
OS
mac
windows
linux
ios
android
Platforms
desktop
server
mobile